Copy Worksheet

Command Prototype

Excel.CopySheet(objExcelWorkBook,sheet,strNewSheetName,bSave)

Command Description

Create a sheet and copy the specified sheet data into the created sheet

Parameter Description

Required Parameter

objExcelWorkBook--Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel))

sheet--The copied worksheet; If a string is used, it refers to the name of the specified sheet; if a number is used, it refers to the index of the specified sheet (starting from 0)

strNewSheetName--New worksheet name

bSave--Save immediately after an operation